SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE Procedure [dbo].[TvShow_Get_ShowAndSeason]
@SeasonId INT, @TvId INT
AS
--SET @TvId = 1182
--SET @SeasonId = 2347
select t.Title, s.Season  from Tv t
left join tvshow_seasons s on s.TvId = t.Id
Where TvId = @TvId and s.SeasonId = @SeasonId
GO
